Queries

Examples of using dates as criteria in Access queries

Date criteria doesn't work in my query

Add to or subtract from date and time values

Create and run an update query

Create and run a delete query

Delete duplicate records with a query

What do I do if I get an error message about not being able to delete from the specified tables?

Sum data by using a query

Count data by using a query

Create a make table query

Add records to a table by using an append query

Common errors when you run an append query

Use a union query to combine multiple queries into a single result

Edit SQL statements to sharpen query results

Access SQL: basic concepts, vocabulary, and syntax

Access SQL: WHERE clause

Access SQL: SELECT clause

GROUP BY Clause

ORDER BY Clause

ALL, DISTINCT, DISTINCTROW, TOP Predicates